Problem Note 50228: The error "cxawork.Staging_promo_detail does not exist" occurs when you run the SAS® Data Integration Studio job cxa_1300_promotion_remerge
 |  |  |  |  |
In SAS Data Integration Studio, when you run the cxa_1300_promotion_remerge job (which is part of the CXA_ETL_FLOW export metadata package), the job fails and generates the following error:
ERROR: cxawork.Staging_promo_detail does not exist.
The cxa_1300_promotion_remerge job merges all keyed data for detail_x_int_promotion* tables. The job fails when it processes the following condition:
MLOGIC(CXA_REMERGE_PROMOTIONS): %IF condition &staged_session_attrib_cnt
ne =%cxa_get_observation_count indsn=&_input1) is TRUE
The error occurs because of a problem with the phrase ne = in the %IF condition. NE stands for "not equal." However, appending the equal sign (=) after it negates that condition. The %IF condition should show only ne.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Customer Experience Analytics | 64-bit Enabled AIX | 6.1 | 6.3 | 9.3 TS1M2 | 9.4 TS1M0 |
| 64-bit Enabled Solaris | 6.1 | 6.3 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Linux for x64 | 6.1 | 6.3 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Solaris for x64 | 6.1 | 6.3 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft® Windows® for x64 | 6.1 | 6.3 | 9.3 TS1M2 | 9.4 TS1M0 | ||
A fix for this issue for SAS Customer Experience Analytics Server 6.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K54.html#50228| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2013-09-19 11:21:13 |
| Date Created: | 2013-06-18 15:53:55 |